FOLLOW US
Board Chairman
Rati Golijashvili

Rati Golijashvili is the General Manager of BioChimPharm, a leading biopharmaceutical company based in Georgia that focuses on research, innovation and production of phage pharmaceutical products (only viable solution to antibiotic resistant infections nowadays).

Growing up in Tbilisi, Georgia, in the family of microbiologists and pharmacists, Rati developed a lifelong mission to combat the global crisis of antimicrobial resistance. He dedicated his career to researching, innovating and making phage medications available globally to patients suffering from antibiotic resistant infections.

As a second-generation phage technology enthusiast, Rati leads the family business at BioChimPharm, which is based on the oldest phage factory in the world, established in 1934. He is the initiator and the Chairman at Georgian Biopharmaceutical Cluster and a Board Member at Georgian Pharmaceutical Association.

Education

Rati holds a Master’s degree in Public Health Policy and Management from Ilia State University and a Bachelor’s degree in Business Administration from the Georgian American University. His work in the field of biotechnology and bacteriophage has made a significant contribution to the fight against antibiotic resistance, and his efforts earned him a spot on the Forbes 30 Under 30 list (2019) in science himself. Now as a jury member for the same list, Rati continues to recognize and support the achievements of young scientists who are making an impact in their respective fields.

 

This website has been produced with the assistance of the European Union (EU) and the United Nations Industrial Development Organization (UNIDO). Its content is the sole responsibility of The Georgian Biopharmaceutical Cluster and do not necessarily reflect the views of the European Union and the United Nations Industrial Development Organization
8.1.32PHP Version3.51sRequest Duration23MBMemory UsageGET {locale?}/{all}Route
  • warninglog[07:25:01] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • Booting (425ms)
  • Application (3.08s)
  • 1 x Application (87.77%)
    3.08s
    1 x Booting (12.1%)
    425.03ms
    7 templates were rendered
    • website.pages.board.show (resources/views/website/pages/board/show.blade.php)21blade
      Params
      0
      model
      1
      section
      2
      post
      3
      breadcrumbs
      4
      language_slugs
      5
      teams_section_post
      6
      teams
      7
      projects
      8
      services
      9
      about_section
      10
      contact
      11
      photo
      12
      news
      13
      partners
      14
      members
      15
      board
      16
      sections
      17
      footerSections
      18
      mainBanner
      19
      cardBanner
      20
      sidebar_menu
    • website.master (resources/views/website/master.blade.php)28blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      model
      4
      section
      5
      post
      6
      breadcrumbs
      7
      language_slugs
      8
      teams_section_post
      9
      teams
      10
      projects
      11
      services
      12
      about_section
      13
      contact
      14
      photo
      15
      news
      16
      partners
      17
      members
      18
      board
      19
      sections
      20
      footerSections
      21
      mainBanner
      22
      cardBanner
      23
      sidebar_menu
      24
      __currentLoopData
      25
      breadcrumb
      26
      loop
      27
      team
    • website.components.head (resources/views/website/components/head.blade.php)28blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      model
      4
      section
      5
      post
      6
      breadcrumbs
      7
      language_slugs
      8
      teams_section_post
      9
      teams
      10
      projects
      11
      services
      12
      about_section
      13
      contact
      14
      photo
      15
      news
      16
      partners
      17
      members
      18
      board
      19
      sections
      20
      footerSections
      21
      mainBanner
      22
      cardBanner
      23
      sidebar_menu
      24
      __currentLoopData
      25
      breadcrumb
      26
      loop
      27
      team
    • website.components.header (resources/views/website/components/header.blade.php)28blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      model
      4
      section
      5
      post
      6
      breadcrumbs
      7
      language_slugs
      8
      teams_section_post
      9
      teams
      10
      projects
      11
      services
      12
      about_section
      13
      contact
      14
      photo
      15
      news
      16
      partners
      17
      members
      18
      board
      19
      sections
      20
      footerSections
      21
      mainBanner
      22
      cardBanner
      23
      sidebar_menu
      24
      __currentLoopData
      25
      breadcrumb
      26
      loop
      27
      team
    • website.components.FooterBanner (resources/views/website/components/FooterBanner.blade.php)31blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      model
      4
      section
      5
      post
      6
      breadcrumbs
      7
      language_slugs
      8
      teams_section_post
      9
      teams
      10
      projects
      11
      services
      12
      about_section
      13
      contact
      14
      photo
      15
      news
      16
      partners
      17
      members
      18
      board
      19
      sections
      20
      footerSections
      21
      mainBanner
      22
      cardBanner
      23
      sidebar_menu
      24
      __currentLoopData
      25
      breadcrumb
      26
      loop
      27
      team
      28
      subSec
      29
      value
      30
      k
    • website.components.footer (resources/views/website/components/footer.blade.php)31blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      model
      4
      section
      5
      post
      6
      breadcrumbs
      7
      language_slugs
      8
      teams_section_post
      9
      teams
      10
      projects
      11
      services
      12
      about_section
      13
      contact
      14
      photo
      15
      news
      16
      partners
      17
      members
      18
      board
      19
      sections
      20
      footerSections
      21
      mainBanner
      22
      cardBanner
      23
      sidebar_menu
      24
      __currentLoopData
      25
      breadcrumb
      26
      loop
      27
      team
      28
      subSec
      29
      value
      30
      k
    • website.components.scripts (resources/views/website/components/scripts.blade.php)31blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      model
      4
      section
      5
      post
      6
      breadcrumbs
      7
      language_slugs
      8
      teams_section_post
      9
      teams
      10
      projects
      11
      services
      12
      about_section
      13
      contact
      14
      photo
      15
      news
      16
      partners
      17
      members
      18
      board
      19
      sections
      20
      footerSections
      21
      mainBanner
      22
      cardBanner
      23
      sidebar_menu
      24
      __currentLoopData
      25
      breadcrumb
      26
      loop
      27
      team
      28
      subSec
      29
      value
      30
      k
    uri
    GET {locale?}/{all}
    middleware
    locale, web
    controller
    App\Http\Controllers\Website\RoutesController@index
    namespace
    prefix
    {locale?}
    where
    file
    App/Http/Controllers/Website/RoutesController.php:13-39
    204 statements were executed, 159 of which were duplicated, 45 unique346ms
    • select * from `slugs` where `fullSlug` = 'en/rati-golijashvili' limit 1
      8.57ms/App/Http/Controllers/Website/RoutesController.php:17pharmacl_phar
      Metadata
      Bindings
      • 0. en/rati-golijashvili
      Backtrace
      • 15. /App/Http/Controllers/Website/RoutesController.php:17
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `posts` where `posts`.`id` = 233 limit 1
      3.11ms/App/Http/Controllers/Website/RoutesController.php:23pharmacl_phar
      Metadata
      Bindings
      • 0. 233
      Backtrace
      • 19. /App/Http/Controllers/Website/RoutesController.php:23
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `post_translations` where `post_translations`.`post_id` = 233 and `post_translations`.`post_id` is not null
      3.01ms/App/Models/Post.php:106pharmacl_phar
      Metadata
      Bindings
      • 0. 233
      Backtrace
      • 18. /App/Models/Post.php:106
      • 20. /App/Models/Post.php:113
      • 21. /App/Http/Controllers/Website/PagesController.php:398
      • 22. /App/Http/Controllers/Website/RoutesController.php:31
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `slugs` where `slugable_type` = 'App\Models\Post' and `slugable_id` = 233 and `locale` = 'en' limit 1
      1.41ms/App/Models/Post.php:67pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Post
      • 1. 233
      • 2. en
      Backtrace
      • 15. /App/Models/Post.php:67
      • 16. /App/Http/Controllers/Website/PagesController.php:406
      • 17. /App/Http/Controllers/Website/RoutesController.php:31
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
    • select * from `sections` where `id` = 89 limit 1
      2.8ms/App/Http/Controllers/Website/PagesController.php:410pharmacl_phar
      Metadata
      Bindings
      • 0. 89
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:410
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `section_translations` where `section_translations`.`section_id` in (89)
      2.68ms/App/Http/Controllers/Website/PagesController.php:410pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:410
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 89 and `locale` = 'en' limit 1
      1.61ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 89
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. /App/Http/Controllers/Website/PagesController.php:413
      • 17. /App/Http/Controllers/Website/RoutesController.php:31
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
    • select * from `posts` where `section_id` = 233 and `active_on_home` = 1
      1.25ms/App/Http/Controllers/Website/PagesController.php:419pharmacl_phar
      Metadata
      Bindings
      • 0. 233
      • 1. 1
      Backtrace
      • 14. /App/Http/Controllers/Website/PagesController.php:419
      • 15. /App/Http/Controllers/Website/RoutesController.php:31
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select `posts`.*, `post_translations`.`text`, `post_translations`.`desc`, `post_translations`.`title`, `post_translations`.`locale_additional`, `post_translations`.`slug` from `posts` inner join `post_translations` on `posts`.`id` = `post_translations`.`post_id` where `posts`.`id` = 233 and `post_translations`.`locale` = 'en' limit 1
      1.32ms/App/Http/Controllers/Website/PagesController.php:428pharmacl_phar
      Metadata
      Bindings
      • 0. 233
      • 1. en
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:428
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `post_files` where `post_files`.`post_id` in (233)
      3.03ms/App/Http/Controllers/Website/PagesController.php:428pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:428
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `id` = 89 limit 1
      1.14ms/App/Http/Controllers/Website/PagesController.php:431pharmacl_phar
      Metadata
      Bindings
      • 0. 89
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:431
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `section_translations` where `section_translations`.`section_id` in (89)
      1.04ms/App/Http/Controllers/Website/PagesController.php:431pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:431
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `posts` where `posts`.`section_id` in (89) order by `date` desc
      1.18ms/App/Http/Controllers/Website/PagesController.php:431pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:431
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `post_translations` where `post_translations`.`post_id` in (233, 258, 259, 431) and `locale` = 'en'
      1.51ms/App/Http/Controllers/Website/PagesController.php:431pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 25. /App/Http/Controllers/Website/PagesController.php:431
      • 26. /App/Http/Controllers/Website/RoutesController.php:31
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `id` = 89 limit 1
      1.11ms/App/Http/Controllers/Website/PagesController.php:432pharmacl_phar
      Metadata
      Bindings
      • 0. 89
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:432
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `section_translations` where `section_translations`.`section_id` in (89)
      940μs/App/Http/Controllers/Website/PagesController.php:432pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:432
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `posts` where `posts`.`section_id` in (89) order by `date` desc
      1.08ms/App/Http/Controllers/Website/PagesController.php:432pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:432
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `post_translations` where `post_translations`.`post_id` in (233, 258, 259, 431) and `locale` = 'en'
      1.12ms/App/Http/Controllers/Website/PagesController.php:432pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 25. /App/Http/Controllers/Website/PagesController.php:432
      • 26. /App/Http/Controllers/Website/RoutesController.php:31
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `type_id` = 7 limit 1
      1.06ms/App/Http/Controllers/Website/PagesController.php:433pharmacl_phar
      Metadata
      Bindings
      • 0. 7
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:433
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `type_id` = 6 limit 1
      970μs/App/Http/Controllers/Website/PagesController.php:434pharmacl_phar
      Metadata
      Bindings
      • 0. 6
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:434
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `type_id` = 3 limit 1
      1.03ms/App/Http/Controllers/Website/PagesController.php:435pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:435
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `section_translations` where `section_translations`.`section_id` in (32)
      1.03ms/App/Http/Controllers/Website/PagesController.php:435pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:435
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `posts` where `posts`.`section_id` in (32) order by `date` desc
      1.24ms/App/Http/Controllers/Website/PagesController.php:435pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:435
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `post_translations` where `post_translations`.`post_id` in (65) and `locale` = 'en'
      1.18ms/App/Http/Controllers/Website/PagesController.php:435pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 25. /App/Http/Controllers/Website/PagesController.php:435
      • 26. /App/Http/Controllers/Website/RoutesController.php:31
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `type_id` = 4 limit 1
      1.22ms/App/Http/Controllers/Website/PagesController.php:436pharmacl_phar
      Metadata
      Bindings
      • 0. 4
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:436
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `section_translations` where `section_translations`.`section_id` in (90)
      1.06ms/App/Http/Controllers/Website/PagesController.php:436pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:436
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `posts` where `posts`.`section_id` in (90) order by `date` desc
      1.26ms/App/Http/Controllers/Website/PagesController.php:436pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:436
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `post_translations` where `post_translations`.`post_id` in (158) and `locale` = 'en'
      1.34ms/App/Http/Controllers/Website/PagesController.php:436pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 25. /App/Http/Controllers/Website/PagesController.php:436
      • 26. /App/Http/Controllers/Website/RoutesController.php:31
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `type_id` = 2 limit 1
      1.26ms/App/Http/Controllers/Website/PagesController.php:437pharmacl_phar
      Metadata
      Bindings
      • 0. 2
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:437
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `section_translations` where `section_translations`.`section_id` in (81)
      1.21ms/App/Http/Controllers/Website/PagesController.php:437pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:437
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `posts` where `posts`.`section_id` in (81) order by `date` desc
      1.27ms/App/Http/Controllers/Website/PagesController.php:437pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:437
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `post_translations` where `post_translations`.`post_id` in (123, 196, 197, 435, 445, 448, 449) and `locale` = 'en'
      1.89ms/App/Http/Controllers/Website/PagesController.php:437pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 25. /App/Http/Controllers/Website/PagesController.php:437
      • 26. /App/Http/Controllers/Website/RoutesController.php:31
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `id` = 89 limit 1
      1.14ms/App/Http/Controllers/Website/PagesController.php:438pharmacl_phar
      Metadata
      Bindings
      • 0. 89
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:438
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `section_translations` where `section_translations`.`section_id` in (89)
      1.19ms/App/Http/Controllers/Website/PagesController.php:438pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:438
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `posts` where `posts`.`section_id` in (89) order by `date` desc
      1.28ms/App/Http/Controllers/Website/PagesController.php:438pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:438
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `post_translations` where `post_translations`.`post_id` in (233, 258, 259, 431) and `locale` = 'en'
      1.42ms/App/Http/Controllers/Website/PagesController.php:438pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 25. /App/Http/Controllers/Website/PagesController.php:438
      • 26. /App/Http/Controllers/Website/RoutesController.php:31
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `type_id` = 15 limit 1
      1.34ms/App/Http/Controllers/Website/PagesController.php:439pharmacl_phar
      Metadata
      Bindings
      • 0. 15
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:439
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `section_translations` where `section_translations`.`section_id` in (87)
      1.5ms/App/Http/Controllers/Website/PagesController.php:439pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:439
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `posts` where `posts`.`section_id` in (87) order by `date` desc
      1.64ms/App/Http/Controllers/Website/PagesController.php:439pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:439
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `post_translations` where `post_translations`.`post_id` in (145, 154) and `locale` = 'en'
      1.18ms/App/Http/Controllers/Website/PagesController.php:439pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 25. /App/Http/Controllers/Website/PagesController.php:439
      • 26. /App/Http/Controllers/Website/RoutesController.php:31
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `type_id` = 17 and `id` = 89 limit 1
      1.09ms/App/Http/Controllers/Website/PagesController.php:440pharmacl_phar
      Metadata
      Bindings
      • 0. 17
      • 1. 89
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:440
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `section_translations` where `section_translations`.`section_id` in (89)
      1.25ms/App/Http/Controllers/Website/PagesController.php:440pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:440
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `type_id` = 9 limit 1
      1.26ms/App/Http/Controllers/Website/PagesController.php:441pharmacl_phar
      Metadata
      Bindings
      • 0. 9
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:441
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `section_translations` where `section_translations`.`section_id` in (78)
      2.2ms/App/Http/Controllers/Website/PagesController.php:441pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:441
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `posts` where `posts`.`section_id` in (78) order by `date` desc
      1.63ms/App/Http/Controllers/Website/PagesController.php:441pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:441
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `post_translations` where `post_translations`.`post_id` in (116, 163) and `locale` = 'en'
      1.57ms/App/Http/Controllers/Website/PagesController.php:441pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 25. /App/Http/Controllers/Website/PagesController.php:441
      • 26. /App/Http/Controllers/Website/RoutesController.php:31
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • update `posts` set `views` = 2048, `posts`.`updated_at` = '2025-08-13 07:25:00' where `id` = 233
      4.38ms/App/Http/Controllers/Website/PagesController.php:445pharmacl_phar
      Metadata
      Bindings
      • 0. 2048
      • 1. 2025-08-13 07:25:00
      • 2. 233
      Backtrace
      • 13. /App/Http/Controllers/Website/PagesController.php:445
      • 14. /App/Http/Controllers/Website/RoutesController.php:31
      • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) and exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1) and `parent_id` is null order by `order` asc, `created_at` desc
      4.97ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 1
      • 3. 1
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:36
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (32, 84, 90, 91, 93, 102, 104) and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) order by `order` asc, `order` asc, `created_at` desc
      2.38ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) and `locale` = 'en'
      1.95ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`id` in (32, 84, 91, 93, 102, 104)
      1.63ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where 0 = 1
      1.21ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 29. /App/Http/View/Composers/WebsiteComposer.php:36
      • 31. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 32. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 33. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 34. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) order by `order` asc
      2.32ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      2.16ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `menu_sections` where `menu_sections`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.82ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 2) order by `order` asc
      2.25ms/App/Http/View/Composers/WebsiteComposer.php:45pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 2
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 1 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` asc
      6.32ms/App/Http/View/Composers/WebsiteComposer.php:52pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:52
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 3 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` desc, `date` desc
      1.5ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:62
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banner_translations` where `locale` = 'en' and `banner_translations`.`banner_id` in (28, 29, 30, 31)
      1.13ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `post_translations` where `post_translations`.`post_id` = 233 and `post_translations`.`post_id` is not null
      1.17ms/App/Models/Post.php:106pharmacl_phar
      Metadata
      Bindings
      • 0. 233
      Backtrace
      • 18. /App/Models/Post.php:106
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:317
      • 23. view::e84fecde24f80a15456282ba3bc7aedb89c386f3:31
    • select * from `slugs` where `slugable_type` = 'App\Models\Post' and `slugable_id` = 258 and `locale` = 'en' limit 1
      1.22ms/App/Models/Post.php:67pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Post
      • 1. 258
      • 2. en
      Backtrace
      • 15. /App/Models/Post.php:67
      • 16. view::e84fecde24f80a15456282ba3bc7aedb89c386f3:121
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Post' and `slugable_id` = 259 and `locale` = 'en' limit 1
      1.75ms/App/Models/Post.php:67pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Post
      • 1. 259
      • 2. en
      Backtrace
      • 15. /App/Models/Post.php:67
      • 16. view::e84fecde24f80a15456282ba3bc7aedb89c386f3:121
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Post' and `slugable_id` = 431 and `locale` = 'en' limit 1
      1.32ms/App/Models/Post.php:67pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Post
      • 1. 431
      • 2. en
      Backtrace
      • 15. /App/Models/Post.php:67
      • 16. view::e84fecde24f80a15456282ba3bc7aedb89c386f3:121
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) and exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1) and `parent_id` is null order by `order` asc, `created_at` desc
      4.74ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 1
      • 3. 1
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:36
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (32, 84, 90, 91, 93, 102, 104) and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) order by `order` asc, `order` asc, `created_at` desc
      2.29ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) and `locale` = 'en'
      1.07ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`id` in (32, 84, 91, 93, 102, 104)
      720μs/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where 0 = 1
      720μs/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 29. /App/Http/View/Composers/WebsiteComposer.php:36
      • 31. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 32. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 33. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 34. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) order by `order` asc
      950μs/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      890μs/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `menu_sections` where `menu_sections`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      680μs/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 2) order by `order` asc
      1.46ms/App/Http/View/Composers/WebsiteComposer.php:45pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 2
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 1 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` asc
      1.29ms/App/Http/View/Composers/WebsiteComposer.php:52pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:52
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 3 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` desc, `date` desc
      1.03ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:62
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banner_translations` where `locale` = 'en' and `banner_translations`.`banner_id` in (28, 29, 30, 31)
      740μs/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) and exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1) and `parent_id` is null order by `order` asc, `created_at` desc
      1.45ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 1
      • 3. 1
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:36
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (32, 84, 90, 91, 93, 102, 104) and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) order by `order` asc, `order` asc, `created_at` desc
      1.1ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) and `locale` = 'en'
      1.41ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`id` in (32, 84, 91, 93, 102, 104)
      1.13ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where 0 = 1
      860μs/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 29. /App/Http/View/Composers/WebsiteComposer.php:36
      • 31. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 32. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 33. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 34. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) order by `order` asc
      1.29ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.34ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `menu_sections` where `menu_sections`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.08ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 2) order by `order` asc
      1.86ms/App/Http/View/Composers/WebsiteComposer.php:45pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 2
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 1 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` asc
      1.58ms/App/Http/View/Composers/WebsiteComposer.php:52pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:52
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 3 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` desc, `date` desc
      1.59ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:62
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banner_translations` where `locale` = 'en' and `banner_translations`.`banner_id` in (28, 29, 30, 31)
      1.2ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) and exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1) and `parent_id` is null order by `order` asc, `created_at` desc
      2.44ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 1
      • 3. 1
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:36
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (32, 84, 90, 91, 93, 102, 104) and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) order by `order` asc, `order` asc, `created_at` desc
      1.79ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) and `locale` = 'en'
      1.58ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`id` in (32, 84, 91, 93, 102, 104)
      1.12ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where 0 = 1
      790μs/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 29. /App/Http/View/Composers/WebsiteComposer.php:36
      • 31. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 32. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 33. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 34. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) order by `order` asc
      1.27ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.26ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `menu_sections` where `menu_sections`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.05ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 2) order by `order` asc
      1.8ms/App/Http/View/Composers/WebsiteComposer.php:45pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 2
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 1 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` asc
      1.48ms/App/Http/View/Composers/WebsiteComposer.php:52pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:52
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 3 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` desc, `date` desc
      1.42ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:62
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banner_translations` where `locale` = 'en' and `banner_translations`.`banner_id` in (28, 29, 30, 31)
      1.18ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 32 and `locale` = 'en' limit 1
      1.27ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 32
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:28
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 101 and `locale` = 'en' limit 1
      1.18ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 101
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 115 and `locale` = 'en' limit 1
      1.5ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 115
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 89 and `locale` = 'en' limit 1
      1.47ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 89
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 82 and `locale` = 'en' limit 1
      1.45ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 82
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 111 and `locale` = 'en' limit 1
      1.54ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 111
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 104 and `locale` = 'en' limit 1
      1.53ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 104
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:28
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 103 and `locale` = 'en' limit 1
      1.5ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 103
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 85 and `locale` = 'en' limit 1
      1.39ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 85
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 91 and `locale` = 'en' limit 1
      1.55ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 91
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:28
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 105 and `locale` = 'en' limit 1
      1.48ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 105
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 92 and `locale` = 'en' limit 1
      1.5ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 92
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 93 and `locale` = 'en' limit 1
      1.51ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 93
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:28
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 96 and `locale` = 'en' limit 1
      1.47ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 96
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 97 and `locale` = 'en' limit 1
      1.44ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 97
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 118 and `locale` = 'en' limit 1
      1.44ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 118
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 84 and `locale` = 'en' limit 1
      1.39ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 84
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:28
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 107 and `locale` = 'en' limit 1
      1.48ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 107
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 108 and `locale` = 'en' limit 1
      1.63ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 108
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 81 and `locale` = 'en' limit 1
      1.57ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 81
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 78 and `locale` = 'en' limit 1
      1.45ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 78
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 80 and `locale` = 'en' limit 1
      1.55ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 80
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 90 and `locale` = 'en' limit 1
      1.53ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 90
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:28
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 32 and `locale` = 'en' limit 1
      1.51ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 32
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:152
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 101 and `locale` = 'en' limit 1
      1.44ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 101
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 115 and `locale` = 'en' limit 1
      1.48ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 115
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 89 and `locale` = 'en' limit 1
      1.5ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 89
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 82 and `locale` = 'en' limit 1
      1.47ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 82
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 111 and `locale` = 'en' limit 1
      1.45ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 111
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 104 and `locale` = 'en' limit 1
      1.6ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 104
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:152
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 103 and `locale` = 'en' limit 1
      1.44ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 103
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 85 and `locale` = 'en' limit 1
      1.95ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 85
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 91 and `locale` = 'en' limit 1
      1.53ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 91
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:152
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 105 and `locale` = 'en' limit 1
      1.45ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 105
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 92 and `locale` = 'en' limit 1
      1.51ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 92
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 93 and `locale` = 'en' limit 1
      1.58ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 93
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:152
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 96 and `locale` = 'en' limit 1
      1.47ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 96
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 97 and `locale` = 'en' limit 1
      1.52ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 97
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 118 and `locale` = 'en' limit 1
      1.51ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 118
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 84 and `locale` = 'en' limit 1
      1.47ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 84
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:152
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 107 and `locale` = 'en' limit 1
      1.87ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 107
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 108 and `locale` = 'en' limit 1
      1.55ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 108
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 102 and `locale` = 'en' limit 1
      1.76ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 102
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:152
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 81 and `locale` = 'en' limit 1
      1.87ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 81
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 78 and `locale` = 'en' limit 1
      1.67ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 78
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 80 and `locale` = 'en' limit 1
      1.56ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 80
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 90 and `locale` = 'en' limit 1
      1.68ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 90
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:152
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) and exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1) and `parent_id` is null order by `order` asc, `created_at` desc
      2.97ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 1
      • 3. 1
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:36
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (32, 84, 90, 91, 93, 102, 104) and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) order by `order` asc, `order` asc, `created_at` desc
      2.08ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) and `locale` = 'en'
      1.87ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`id` in (32, 84, 91, 93, 102, 104)
      1.43ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where 0 = 1
      1.02ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 29. /App/Http/View/Composers/WebsiteComposer.php:36
      • 31. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 32. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 33. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 34. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) order by `order` asc
      1.82ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      2.03ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `menu_sections` where `menu_sections`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.81ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 2) order by `order` asc
      2.83ms/App/Http/View/Composers/WebsiteComposer.php:45pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 2
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 1 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` asc
      2.2ms/App/Http/View/Composers/WebsiteComposer.php:52pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:52
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 3 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` desc, `date` desc
      2.29ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:62
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banner_translations` where `locale` = 'en' and `banner_translations`.`banner_id` in (28, 29, 30, 31)
      1.7ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) and exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1) and `parent_id` is null order by `order` asc, `created_at` desc
      2.11ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 1
      • 3. 1
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:36
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (32, 84, 90, 91, 93, 102, 104) and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) order by `order` asc, `order` asc, `created_at` desc
      1.57ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) and `locale` = 'en'
      2.57ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`id` in (32, 84, 91, 93, 102, 104)
      1.1ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where 0 = 1
      1.08ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 29. /App/Http/View/Composers/WebsiteComposer.php:36
      • 31. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 32. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 33. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 34. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) order by `order` asc
      1.72ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.74ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `menu_sections` where `menu_sections`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.43ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 2) order by `order` asc
      2.22ms/App/Http/View/Composers/WebsiteComposer.php:45pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 2
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 1 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` asc
      1.99ms/App/Http/View/Composers/WebsiteComposer.php:52pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:52
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 3 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` desc, `date` desc
      2.5ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:62
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banner_translations` where `locale` = 'en' and `banner_translations`.`banner_id` in (28, 29, 30, 31)
      2.35ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 32 and `locale` = 'en' limit 1
      2.02ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 32
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 32 and `section_translations`.`section_id` is not null
      1.69ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 32
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 89 and `locale` = 'en' limit 1
      1.77ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 89
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 89 and `section_translations`.`section_id` is not null
      2.22ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 89
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 82 and `locale` = 'en' limit 1
      2.06ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 82
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 82 and `section_translations`.`section_id` is not null
      1.74ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 82
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 104 and `locale` = 'en' limit 1
      1.77ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 104
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 104 and `section_translations`.`section_id` is not null
      2.01ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 104
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 91 and `locale` = 'en' limit 1
      1.79ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 91
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 91 and `section_translations`.`section_id` is not null
      2.1ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 91
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 92 and `locale` = 'en' limit 1
      1.79ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 92
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 92 and `section_translations`.`section_id` is not null
      1.94ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 92
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 93 and `locale` = 'en' limit 1
      1.9ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 93
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 93 and `section_translations`.`section_id` is not null
      1.83ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 93
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 84 and `locale` = 'en' limit 1
      1.83ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 84
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 84 and `section_translations`.`section_id` is not null
      1.69ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 84
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 81 and `locale` = 'en' limit 1
      1.58ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 81
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 81 and `section_translations`.`section_id` is not null
      1.67ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 81
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 78 and `locale` = 'en' limit 1
      1.76ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 78
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 78 and `section_translations`.`section_id` is not null
      1.43ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 78
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 90 and `locale` = 'en' limit 1
      1.52ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 90
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 90 and `section_translations`.`section_id` is not null
      1.48ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 90
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) and exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1) and `parent_id` is null order by `order` asc, `created_at` desc
      7.32ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 1
      • 3. 1
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:36
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (32, 84, 90, 91, 93, 102, 104) and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) order by `order` asc, `order` asc, `created_at` desc
      1.98ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) and `locale` = 'en'
      1.69ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`id` in (32, 84, 91, 93, 102, 104)
      1.55ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where 0 = 1
      1ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 29. /App/Http/View/Composers/WebsiteComposer.php:36
      • 31. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 32. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 33. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 34. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) order by `order` asc
      1.5ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.55ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `menu_sections` where `menu_sections`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.31ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 2) order by `order` asc
      2.14ms/App/Http/View/Composers/WebsiteComposer.php:45pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 2
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 1 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` asc
      1.75ms/App/Http/View/Composers/WebsiteComposer.php:52pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:52
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 3 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` desc, `date` desc
      1.75ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:62
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banner_translations` where `locale` = 'en' and `banner_translations`.`banner_id` in (28, 29, 30, 31)
      1.4ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    App\Models\BannerTranslation
    28
    App\Models\Banner
    35
    App\Models\MenuSection
    91
    App\Models\PostFile
    1
    App\Models\SectionTranslation
    259
    App\Models\Section
    297
    App\Models\PostTranslation
    29
    App\Models\Post
    27
    App\Models\Slug
    64
        locale
        en
        _token
        hsIw2CfkxNtvtAKENGmxPJsIC2ZwlRGHPKpvrB8E
        _previous
        array:1 [ "url" => "https://www.pharmacluster.org/en/rati-golijashvili" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /en/rati-golijashvili
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:15 [ "host" => array:1 [ 0 => "www.pharmacluster.org" ] "priority" => array:1 [ 0 => "u=0, i" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] ]
        request_server
        0 of 0
        array:75 [ "USER" => "pharmacl" "HOME" => "/home/pharmacl" "SCRIPT_NAME" => "/public/index.php" "REQUEST_URI" => "/en/rati-golijashvili" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/2.0" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_URL" => "/public/en/rati-golijashvili" "REMOTE_PORT" => "26252" "SCRIPT_FILENAME" => "/home/pharmacl/domains/pharmacluster.org/private_html/public/index.php" "SERVER_ADMIN" => "webmaster@pharmacluster.org" "CONTEXT_DOCUMENT_ROOT" => "/home/pharmacl/domains/pharmacluster.org/private_html" "CONTEXT_PREFIX" => "" "REQUEST_SCHEME" => "https" "DOCUMENT_ROOT" => "/home/pharmacl/domains/pharmacluster.org/private_html" "REMOTE_ADDR" => "216.73.216.106" "SERVER_PORT" => "443" "SERVER_ADDR" => "91.239.206.137" "SERVER_NAME" => "www.pharmacluster.org" "SERVER_SOFTWARE" => "Apache/2" "SERVER_SIGNATURE" => "" "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin" "HTTP_HOST" => "www.pharmacluster.org" "HTTP_PRIORITY" => "u=0, i" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "proxy-nokeepalive" => "1" "H2_STREAM_TAG" => "2320665-2068-1" "H2_STREAM_ID" => "1" "H2_PUSHED_ON" => "" "H2_PUSHED" => "" "H2_PUSH" => "off" "H2PUSH" => "off" "HTTP2" => "on" "SSL_TLS_SNI" => "www.pharmacluster.org" "HTTPS" => "on" "UNIQUE_ID" => "aJwFi_IIiPjpILSqef_-8gAAAzA" "REDIRECT_STATUS" => "200" "REDIRECT_H2_STREAM_TAG" => "2320665-2068-1" "REDIRECT_H2_STREAM_ID" => "1" "REDIRECT_H2_PUSHED_ON" => "" "REDIRECT_H2_PUSHED" => "" "REDIRECT_H2_PUSH" => "off" "REDIRECT_H2PUSH" => "off" "REDIRECT_HTTP2" => "on" "REDIRECT_SSL_TLS_SNI" => "www.pharmacluster.org" "REDIRECT_HTTPS" => "on" "REDIRECT_UNIQUE_ID" => "aJwFi_IIiPjpILSqef_-8gAAAzA" "REDIRECT_REDIRECT_STATUS" => "200" "REDIRECT_REDIRECT_H2_STREAM_TAG" => "2320665-2068-1" "REDIRECT_REDIRECT_H2_STREAM_ID" => "1" "REDIRECT_REDIRECT_H2_PUSHED_ON" => "" "REDIRECT_REDIRECT_H2_PUSHED" => "" "REDIRECT_REDIRECT_H2_PUSH" => "off" "REDIRECT_REDIRECT_H2PUSH" => "off" "REDIRECT_REDIRECT_HTTP2" => "on" "REDIRECT_REDIRECT_SSL_TLS_SNI" => "www.pharmacluster.org" "REDIRECT_REDIRECT_HTTPS" => "on" "REDIRECT_REDIRECT_UNIQUE_ID" => "aJwFi_IIiPjpILSqef_-8gAAAzA" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/public/index.php" "REQUEST_TIME_FLOAT" => 1755055499.4849 "REQUEST_TIME" => 1755055499 ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Wed, 13 Aug 2025 03:25:02 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImZvb1preUhBcnZOTlM3TUFrV1ZkaHc9PSIsInZhbHVlIjoiYmFrZ3QwQ1BFWDAweVFvbzVPRmFKRC96NE1keng2T3V5V2Q4QWlzUTVEM3psK0g2WGsvUkpuUURkV0xVWnpkUTU1a1FwWGFzWVlUN05kVGRlajBXaFRDQm1sTjAwNFIyV2R3QjBSOWQ0Zy8vc0tuQUNlc0M0elVmR3N3bmErdGoiLCJtYWMiOiJkMjAzNTE5YTljZjEwZjdjZGZlNDQ4ZjEyMWQ0OWQ0OTljOWFhODY2ZTY1MDFmNzdmMDBjZmQ4MDU4MjY5ZDRjIiwidGFnIjoiIn0%3D; expires=Wed, 13-Aug-2025 05:25:02 GMT; Max-Age=7199; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6ImZvb1preUhBcnZOTlM3TUFrV1ZkaHc9PSIsInZhbHVlIjoiYmFrZ3QwQ1BFWDAweVFvbzVPRmFKRC96NE1keng2T3V5V2Q4QWlzUTVEM3psK0g2WGsvUkpuUURkV0xVWnpkUTU1a1FwW" 1 => "geopharmacy_session=eyJpdiI6IjBmcC82NHFyRGZ2RENEV3BZRk1UR0E9PSIsInZhbHVlIjoiVStXTHZZSTlIRllWT21qTmNONnhpQUdpdzhpLzBJOUVqUkp0bGN6TTRIV0JmTng1ZGZYdndLdkVXTmJNdStaK2JIUUF1WDhqZUh0bVNWTzZjU2JTMVBIV2crVEs4WjhKVFRyUVYyL0c1eXZyZU1MSllwR3JiRXBUb3FXZ3hVWDkiLCJtYWMiOiIzZDM1MDVhODZiMTdjMDlmZGU3NDYwMTExNDhjNTgwOWE1YTYyOTQzMTFiMmY4ZDE3ODFkODg5YjY3YWU2MTYyIiwidGFnIjoiIn0%3D; expires=Wed, 13-Aug-2025 05:25:02 GMT; Max-Age=7199; path=/; httponly; samesite=laxgeopharmacy_session=eyJpdiI6IjBmcC82NHFyRGZ2RENEV3BZRk1UR0E9PSIsInZhbHVlIjoiVStXTHZZSTlIRllWT21qTmNONnhpQUdpdzhpLzBJOUVqUkp0bGN6TTRIV0JmTng1ZGZYdndLdkVXTmJNdSta" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImZvb1preUhBcnZOTlM3TUFrV1ZkaHc9PSIsInZhbHVlIjoiYmFrZ3QwQ1BFWDAweVFvbzVPRmFKRC96NE1keng2T3V5V2Q4QWlzUTVEM3psK0g2WGsvUkpuUURkV0xVWnpkUTU1a1FwWGFzWVlUN05kVGRlajBXaFRDQm1sTjAwNFIyV2R3QjBSOWQ0Zy8vc0tuQUNlc0M0elVmR3N3bmErdGoiLCJtYWMiOiJkMjAzNTE5YTljZjEwZjdjZGZlNDQ4ZjEyMWQ0OWQ0OTljOWFhODY2ZTY1MDFmNzdmMDBjZmQ4MDU4MjY5ZDRjIiwidGFnIjoiIn0%3D; expires=Wed, 13-Aug-2025 05:25:02 GMT; path=/XSRF-TOKEN=eyJpdiI6ImZvb1preUhBcnZOTlM3TUFrV1ZkaHc9PSIsInZhbHVlIjoiYmFrZ3QwQ1BFWDAweVFvbzVPRmFKRC96NE1keng2T3V5V2Q4QWlzUTVEM3psK0g2WGsvUkpuUURkV0xVWnpkUTU1a1FwW" 1 => "geopharmacy_session=eyJpdiI6IjBmcC82NHFyRGZ2RENEV3BZRk1UR0E9PSIsInZhbHVlIjoiVStXTHZZSTlIRllWT21qTmNONnhpQUdpdzhpLzBJOUVqUkp0bGN6TTRIV0JmTng1ZGZYdndLdkVXTmJNdStaK2JIUUF1WDhqZUh0bVNWTzZjU2JTMVBIV2crVEs4WjhKVFRyUVYyL0c1eXZyZU1MSllwR3JiRXBUb3FXZ3hVWDkiLCJtYWMiOiIzZDM1MDVhODZiMTdjMDlmZGU3NDYwMTExNDhjNTgwOWE1YTYyOTQzMTFiMmY4ZDE3ODFkODg5YjY3YWU2MTYyIiwidGFnIjoiIn0%3D; expires=Wed, 13-Aug-2025 05:25:02 GMT; path=/; httponlygeopharmacy_session=eyJpdiI6IjBmcC82NHFyRGZ2RENEV3BZRk1UR0E9PSIsInZhbHVlIjoiVStXTHZZSTlIRllWT21qTmNONnhpQUdpdzhpLzBJOUVqUkp0bGN6TTRIV0JmTng1ZGZYdndLdkVXTmJNdSta" ] ]
        session_attributes
        0 of 0
        array:5 [ "locale" => "en" "_token" => "hsIw2CfkxNtvtAKENGmxPJsIC2ZwlRGHPKpvrB8E" "_previous" => array:1 [ "url" => "https://www.pharmacluster.org/en/rati-golijashvili" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]